Also, to explore and test the new update capabilities initially, you may find it convenient to embed the XMLQUERY function with the transform in a SELECT statement rather than an UPDATE. 另外,在研究和测试新的更新功能时,在SELECT语句(而不是UPDATE语句)中嵌入包含转换表达式的XMLQUERY函数可能更方便。
First, we will create a scalar transform function named ADDRESS_TRANSFORM, using the CREATE FUNCTION ( SQL Scalar, Table, or Row) statement. 首先,我们将使用CREATEFUNCTION(SQLScalar、Table或Row)语句,创建一个名为ADDRESSTRANSFORM的标量转换函数。
The CREATE TRANSFORM statement enables an existing function to be used as a transform function. CREATETRANSFORM允许将现有的函数用作转换函数。
Most of the examples in this article show the transform expression in an SQL UPDATE statement. 本文中的大多数示例在SQLUPDATE语句中使用转换表达式。
In order for a PERL program to transform a dynamic SQL statement into executable form, you need to first use the prepare method, and then bind parameters using the bind_param method. 为了让Perl程序将动态SQL语句转换成可执行的格式,需要首先使用prepare方法,然后使用bindparam方法来绑定参数。